This page displays various information about the shootings that occured in 2018. This data was collected from GunViolence.org. The total number of shootings that occured in 2018 is 339 and the total number of lives lost due to shootings is 373. Pompano Beach (Parkland) is the city most impacted by shootings that occurred in 2018. The state that lost the most lives is Florida with 17 deaths.
Casualties are defined as number of injuries and deaths that occured due to an incident. Pompano Beach (Parkland) had the most number of casualties with 34 casualites. Santa Fe had the second most number of casualties.
The table below shows the shows the total casualties due to shootings in 2018, and the number of deaths and injuries as well. From this table we can see which states were affected the most due to shootings in terms of number of deaths, casualties or injuries
| State | Dead | Injured | Casualties |
|---|---|---|---|
| Alabama | 12 | 55 | 67 |
| Arizona | 4 | 5 | 9 |
| Arkansas | 7 | 17 | 24 |
| California | 50 | 136 | 186 |
| Colorado | 9 | 27 | 36 |
| Connecticut | 0 | 8 | 8 |
| Delaware | 5 | 0 | 5 |
| District of Columbia | 2 | 23 | 25 |
| Florida | 48 | 132 | 180 |
| Georgia | 3 | 33 | 36 |
| Illinois | 21 | 150 | 171 |
| Indiana | 10 | 27 | 37 |
| Kansas | 1 | 11 | 12 |
| Kentucky | 7 | 25 | 32 |
| Louisiana | 15 | 50 | 65 |
| Maryland | 13 | 31 | 44 |
| Massachusetts | 0 | 4 | 4 |
| Michigan | 10 | 28 | 38 |
| Minnesota | 1 | 14 | 15 |
| Mississippi | 1 | 17 | 18 |
| Missouri | 12 | 52 | 64 |
| Nebraska | 1 | 16 | 17 |
| Nevada | 3 | 15 | 18 |
| New Jersey | 4 | 54 | 58 |
| New Mexico | 5 | 4 | 9 |
| New York | 5 | 53 | 58 |
| North Carolina | 14 | 37 | 51 |
| Ohio | 13 | 46 | 59 |
| Oklahoma | 2 | 19 | 21 |
| Pennsylvania | 35 | 63 | 98 |
| South Carolina | 5 | 19 | 24 |
| Tennessee | 19 | 68 | 87 |
| Texas | 29 | 62 | 91 |
| Utah | 0 | 4 | 4 |
| Virginia | 2 | 17 | 19 |
| Washington | 4 | 9 | 13 |
| Wisconsin | 1 | 16 | 17 |
This table below shows the top 5 states that were affected by shootings in 2018
| State | Dead | Injured | Casualties |
|---|---|---|---|
| California | 50 | 136 | 186 |
| Florida | 48 | 132 | 180 |
| Illinois | 21 | 150 | 171 |
| Pennsylvania | 35 | 63 | 98 |
| Texas | 29 | 62 | 91 |
I selected this incident by reading the table above and identifying which state had the most number of casualties. The state with the highest number of casualties is California with 186 casualties. Thousand Oaks, California had the highest number of casualites in this state. This incident occured on November 7, 2018 at 99 Rolling Oaks Dr, Thousand Oaks. This incident occured at the Borderline Bar & Grill in Thousand Oaks, California around 11pm. The number of casualties were 15 out of which 13 died and 2 were injured.
This visualisation below will show the location of each shooting that occured in 2018 and the size of the marker will be based on the number of casualites (number injured and dead). From this visualisation you should be able to get a view of the locations of shooting incidents, and the relative comparasion of casualties. When you hover over each point the extra information provided will be the number of injuries, number of deaths, and the location of the incident.
From this visualisation we can see that,
I wanted to see what is the percentage of death in each state due to shootings. I chose to display the information as a scatterplot as this is a measurment of two continuous variables (death rates and total shootings) so the visually impactful way to display this information is as a scatterplot where the maximum and minimum values are easily identified and you can see the position of one state relative to other states.
To get the death percentage information, I created anew dataframe that only includes, state, num_hurt and num_killed and a new column that includes death rates (which are calculated using the information provided in the orginal dataset)
From the plot the following insights are evident: